SELECT Id FROM new_searchtable
where
(town = 'Cornish' and state='NH'
or town = 'Eastman' and state='NH'
or town = 'Enfield' and state='NH'
or town = 'Hanover' and state='NH'
or town = 'Lebanon' and state='NH'
or town = 'Lyme' and state='NH'
or town = 'Plainfield' and state='NH'
)
and (type = 'R' or type ='O')
AND list_price BETWEEN '500000' AND '1000000'
ORDER BY list_price Desc
Upper Valley Area NH Homes page 20
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:This exceptional newly constructed home is ready for a September closing in the Upper Valley's Premier Neighborhood. This Della Style home blends sophisticated design offering 1,600 square feet of beautifully appointed living space in a peaceful setting with local views. Designed for both comfort and elegance, the open floor plan offers hardwood flooring throughout the main level with an abundance of natural light. The kitchen showcases hard marble countertops, soft-close cabinetry with premium finishes, creating a space that's as functional as it is beautiful. Off the kitchen enjoy the gas insert fireplace, vaulted ceiling and morning sun. This home offers 2 bedrooms and 2.5 baths with tiled primary bath and tiled floors as well as quartz counters. Three high-efficiency mini-split systems provide personalized year-round comfort located on the living area and primary bedroom on the main level. The lower level has another mini split with over 1,000sf of finished space with 1/2 bath and sliders to back yard. The 12x12 composite deck off the kitchen has local views west and the covered front porch are both composite for low maintenance and offers additional space to gather. The Rock Ridge Community" offers 326 pristine acres of nature, trails, and riverfront access to all that the Upper Valley has to offer Share the community garden, enjoy socials at the Farmhouse, and the privileges that an HOA provides. Close to I89, DHMC, Dartmouth College, Lebanon 6 Movie Theater, Downtown and plenty of shopping. All interior pictures are from recently built homes.
Description:Beautiful Home for Sale in a Prime Lebanon Location. Welcome to this meticulously maintained, spacious home in one of Lebanon's most desirable neighborhoods. Conveniently located just minutes from Dartmouth Medical Center and Lebanon High School, this property offers comfort, versatility, and exceptional value. The main home features a bright and inviting living room, a spacious family room, 3 bedrooms which includes a primary suite, and 3 bathrooms, providing plenty of room for everyday living and entertaining. A beautiful bay window creates the perfect spot to enjoy your morning coffee while overlooking the yard. A separate one-bedroom apartment offers outstanding flexibility - ideal for rental income, extended family, guests, or a private home office. Outside, you'll find a fully fenced backyard, an oversized garage, and a paved driveway. Numerous upgrades throughout the home reflect the exceptional care and attention the property has received over the years, making it truly move-in ready. This is a rare opportunity to own a beautiful home that combines generous living space, income potential, and an unbeatable location in a welcoming neighborhood.
Description:Experience the timeless charm of this classic 1903 Victorian with a beautiful carriage shed, ideally situated on a generous half-acre lot just minutes from the heart of Enfield and a short drive to Mascoma Lake. Rich in character and architectural detail, this four-bedroom, one-and-a-half-bath home has beautiful wood floors throughout, soaring ceilings, an elegant staircase with a stunning stained-glass window, a living room with fireplace and a formal dining room perfect for entertaining. The third floor offers unique additional space featuring beautiful wainscoted ceiling and walls and period charm. Outside, a carriage shed provides endless possibilities for storage, hobbies, or workshop space or convert into living space! Conveniently located walking distance to town for coffee or dinner or hop on the rail trail just a block away! Don't miss the grand home! Super location just 20 mins to Dartmouth Health! Showings by appointment.
Description:Just a short walk from Dartmouth College, this classic New England home offers comfort, convenience, and the option of long-term rental income. Currently leased through June 2026, it’s an excellent investment opportunity or future personal residence in a highly sought-after location. Featuring 3 bedrooms and 1.5 bathrooms, the home combines traditional character with practical updates. The kitchen opens to a bright dining area overlooking the peaceful, protected woods behind the property—perfect for enjoying the changing seasons in privacy. A spacious deck extends from the side of the house, ideal for outdoor dining or relaxing in nature. The home’s convenient layout includes a cozy living space, plenty of natural light, and laundry in the basement. Located within walking distance of campus, local shops, and restaurants, this property offers the best of Hanover living—with everything you need close by. Listing agent has an ownership interest in the property.
Description:Own a piece of early New England history with waterfront - a rare combination that almost never comes available. This iconic 1812 stone home sits on a level 0.98-acre lot and includes 130 feet of owned Connecticut River frontage just across the quiet country road, offering easy access for kayaking, fishing, paddle boarding, or simply enjoying the ever-changing water views. Inside, the home blends historic character with comfortable living. The first floor offers a warm and inviting living room with wood stove, country kitchen with dining nook, formal dining room, first-floor bedroom, half bath, sun porch, workshop space, and generous storage. Upstairs you'll find a large primary bedroom, office, and full bath, while the third level provides an additional bedroom and flexible bonus space perfect for guests, studio, or work-from-home use. Original details remain throughout - maple floors on the main level, wide pine floors above, and deep farmhouse window trim - creating the charm only a true period home can offer. Outside, the property is equally special, with mature landscaping, established garden areas, patio space, and a workshop/shed. The river frontage across the road expands the lifestyle, giving you your own personal access to the Connecticut River without sacrificing privacy at the house site. Conveniently located just minutes to I-91 and an easy bike ride to Post Pond and Cedar Circle Farm, this property offers a unique blend of history, recreation, and rural tranquility - a setting increasingly difficult to find in the Upper Valley. Just a 20 minute drive to downtown Hanover & Dartmouth College. High School Choice.